In this video we are going to learn the basics of handling the data in tables and functions.
Card copy and paste.
We already have created this small student's data table.
I have added a few more rows to it.
The first thing we must know is how to move around in this table.
If you remember from previous lectures if you want to go to any particular set you can either click
the cell with your mouse or you can use arrow keys on your keyboard to navigate.
But if you are in the first row and you want to go to the end of the table then you'd need not press
the down key so many times you can simply hold the control key of your keyboard and press the down arrow
see.
We are at the end similarly if we want to go to the right and press control and write key
to go to the top control.
Plus a better so when we have used data using these keyboard shortcuts we can easily move to any end
of our table.
Next we are going to discuss very important functions of card copy and paste.
You must have done this in other text programs but let's see how this happens.
In exit there are two combinations.
Cut and paste or copy and paste when we cut and paste data it is removed from the original position
and added at the other place.
It is similar to transferring data from one place to another.
So let's cut the data instead insert C1 to do that we go to cells even and click on card option in the
home menu
when you do this.
You can see the dotted model around the cell which means that the content of this cell is ready to be
transferred.
Now activate cell B1 and click based.
You can see that the content of these cells even are now crossword puzzle B1.
There are two other ways of cutting and pasting.
One is right clicking on the cell and selecting the cut option and then right clicking on the destination
set and selecting the best option
but the fastest way of cutting and pasting is using keyboard shortcut keyboard shortcuts are used to
increase work efficiency.
The keyboard shortcut for cutting is control plus X that is hold only control key and then press the
X alphabet.
When we do this you can see again that are dotted border comes out on the selected tail.
Now we can again select the destination cell and pasty content that we have already caught using the
shortcut for pasting which is control plus we so hold on control key and press the V alphabet key to
transfer the data to the destination cell.
So in cases where we have to do card based multiple times using keyboard shortcut is the best idea.
The other combination is copy plus paste.
The difference is that copy does not remove data from original position.
It just makes a copy of it and we can base this copy wherever we like to.
For example if I want to repeat student name G five pains I will just copy it once by selecting the
set and clicking the copy option here in the home menu.
Again we see that our dotted boarder comes around this said
we can now go to all the cells one by one and deep based within.
This will create five copies of the original and the original will also not be removed again for copy
pasting also.
There are two more ways either do right click and select copy option on the fossil and then right click.
And based on the destinations in
or we can again use shortcuts shortcut for copying is control plus C and you know that the shortcut
for pasting is control plus we know let us copy paste student rule number and marks in the blank since
OK so till now we have moved and copied contents of only one thing but if we want to move an entire
table or some part of this table how can we do that.
We can do that by selecting the entire range of cells that we want to move or copy to select multiple
cells click on the first cell of the part you want to copy who will look like drag the most dearly lost
cell and now leave the click
you will see that the entire selected portion is having a great background.
Now if you had control plus X this entire portion will be caught you can see the dotted border it also
signifies that the contents of this entire part are ready to be moved.
Now click on the part of the sheet that you want to move this data and press control.
V.
The data is transferred.
Similarly for making a duplicate of the entire table.
Select the entire table it see
go to the new location and it control V
now.
As I told you that to increase efficiency.
People use shortcuts of cutting copying and pasting.
Similarly there are shortcuts to help select the required data from the table quickly
so let's say I'm at the first fossil of the table now.
If I want to select the first row I can press and hold the shift key and had the right arrow.
Once this went to make the adjacent sell only I can repeat doing it.
They select all the sellers in this role or I can use another shortcut I'll again go back to defrosted.
Now I will press control shift and now I press the energy
you know control key will take you to the last sale in that direction and pressing shift key will select
all these years.
So this shortcut control plus shift plus direction Key will select all the cells in that direction.
Now you can see that the entire first row is selected.
If I press and hold off key and now her denominator
the second row is also selected.
If you want to select the entire table can you guess what you need to do.
Yes just hold the control key and no press shift and down arrow
in this way we will select the entire table.
To move this table you just need to know press control X or control C to pasted any word as you need
to do control.
We also note that if you have got the selected area by mistake that is you selected the entire table
and you have had control X but you do not want to cut this part.
You do not want to move to any other location but you can see that this area is ready to be transferred
because there is our daughter boarder around the Pleiades selection that is to cancel the card operation.
You just need to press the escape key and that will cancel the card operation the entire table is still
selected only the card operation is cancelled.
Similarly when you are copying once you copy the data will be ready for pasting a limited number of
things.
So if you want to stop wasting it is a good practice that you press escapee after you have pasted it
in your desired location
since we have covered a lot of shortcuts in this lecture.
There are two very important shortcut that you must know these are shortcuts which help us undo our
mistakes.
For example I select the entire table and mistakenly hit delete my entire table is gone.
If I want to get this table back we just have to press control plus Z.
This shortcut is for undoing whatever operation you have done last.
Since we deleted this data in the last operation when we press control it it undid whatever operation
we did last and the number of undo you can do is not limited to one you can undo multiple operations.
So for example if I mistakenly renamed the cell to Auden and renamed the cell to end and I want to undo
both of these operations I just press control these two things.
The first time my last operation was to rename the cell containing name that was undone first.
Now if I press controlled again the cells containing Roland will be corrected next.
But this was the shortcut if you want to undo using the option on the Excel screen.
This is the undo option on the Excel screen and it is also suggesting that what is the last operation
that you did the last operation we did was pasting the data and if you want to undo that based you can
click this icon and it will undo that beast.
But if you do this mistakenly you have to redo it.
For that there is a redo button click on it and that will be done again.
The shortcut for this is controlled by.
However redo is a very rarely used feature but undo is quite often used.
So remember the shortcut for undo control plus Z.
Let me give you a quick summary of what all we covered in this lecture.
We learned how to do card paste and copy paste for cutting and pasting the shortcut was control X and
then control V for copy and pasting the shortcut was controlled C and then controlled we.
We also learn to navigate within our table using just emojis or control plus arrow keys.
We learned selecting different parts of the table using shift plus a low key or control plus shift plus
energy to select entire rule or entire columns at the last.
We also learned how to undo our mistakes using the control plus zig Chalker.